You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'd/\'Huez, base ) name, TYPE FROM ( SELECT gl.placeid, TYPE , MAX( IF( languageco' at line 1Fehler mit Abfrage:
SELECT placeid, type,COALESCE( de/Webcam-Alpe d/\'Huez, base ) name, TYPE FROM ( SELECT gl.placeid, TYPE , MAX( IF( languagecode = 'de/Webcam-Alpe d/\'Huez', name, NULL ) ) AS de/Webcam-Alpe d/\'Huez, MAX( IF( languagecode = baselang, name, NULL ) ) AS base FROM places_languages gl INNER JOIN places cs ON gl.placeid = cs.idplace WHERE placeid = '0' GROUP BY placeid )subq